Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 456240 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 30.9 MiB |
| Average record size in memory | 71.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Boolean | 2 |
| Categorical | 3 |
preco_checkout is highly correlated with preco_base | High correlation |
preco_base is highly correlated with preco_checkout | High correlation |
preco_checkout is highly correlated with preco_base | High correlation |
preco_base is highly correlated with preco_checkout | High correlation |
preco_checkout is highly correlated with preco_base | High correlation |
preco_base is highly correlated with preco_checkout | High correlation |
df_index is highly correlated with cidade_codigo and 3 other fields | High correlation |
pagina_destaque is highly correlated with email_para_promocao | High correlation |
cidade_codigo is highly correlated with df_index and 4 other fields | High correlation |
preco_checkout is highly correlated with preco_base and 3 other fields | High correlation |
preco_base is highly correlated with preco_checkout and 3 other fields | High correlation |
qtd_pedido is highly correlated with categoria | High correlation |
cozinha is highly correlated with preco_checkout and 3 other fields | High correlation |
refeicao_id is highly correlated with preco_checkout and 3 other fields | High correlation |
regiao_codigo is highly correlated with df_index and 2 other fields | High correlation |
loja_tipo is highly correlated with cidade_codigo and 1 other fields | High correlation |
loja_id is highly correlated with df_index and 3 other fields | High correlation |
email_para_promocao is highly correlated with pagina_destaque | High correlation |
op_area is highly correlated with df_index and 3 other fields | High correlation |
categoria is highly correlated with preco_checkout and 4 other fields | High correlation |
cozinha is highly correlated with categoria | High correlation |
categoria is highly correlated with cozinha | High correlation |
df_index is uniformly distributed | Uniform |
df_index has unique values | Unique |
Reproduction
| Analysis started | 2021-08-29 18:36:51.815858 |
|---|---|
| Analysis finished | 2021-08-29 18:37:36.757318 |
| Duration | 44.94 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 456240 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 228264.5684 |
| Minimum | 0 |
|---|---|
| Maximum | 456547 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 22825.95 |
| Q1 | 114138.75 |
| median | 228260.5 |
| Q3 | 342376.25 |
| 95-th percentile | 433719.05 |
| Maximum | 456547 |
| Range | 456547 |
| Interquartile range (IQR) | 228237.5 |
Descriptive statistics
| Standard deviation | 131785.5114 |
|---|---|
| Coefficient of variation (CV) | 0.5773366944 |
| Kurtosis | -1.199740008 |
| Mean | 228264.5684 |
| Median Absolute Deviation (MAD) | 114119 |
| Skewness | 0.0001090528568 |
| Sum | 1.041434267 × 1011 |
| Variance | 1.7367421 × 1010 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 248620 | 1 | < 0.1% |
| 201527 | 1 | < 0.1% |
| 203574 | 1 | < 0.1% |
| 197429 | 1 | < 0.1% |
| 199476 | 1 | < 0.1% |
| 209715 | 1 | < 0.1% |
| 211762 | 1 | < 0.1% |
| 205617 | 1 | < 0.1% |
| 207664 | 1 | < 0.1% |
| Other values (456230) | 456230 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 456547 | 1 | |
| 456546 | 1 | |
| 456545 | 1 | |
| 456544 | 1 | |
| 456543 | 1 | |
| 456542 | 1 | |
| 456541 | 1 | |
| 456540 | 1 | |
| 456539 | 1 | |
| 456538 | 1 |
semana
Real number (ℝ≥0)
| Distinct | 145 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 74.78105602 |
| Minimum | 1 |
|---|---|
| Maximum | 145 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 39 |
| median | 76 |
| Q3 | 111 |
| 95-th percentile | 139 |
| Maximum | 145 |
| Range | 144 |
| Interquartile range (IQR) | 72 |
Descriptive statistics
| Standard deviation | 41.51946501 |
|---|---|
| Coefficient of variation (CV) | 0.555213676 |
| Kurtosis | -1.179373225 |
| Mean | 74.78105602 |
| Median Absolute Deviation (MAD) | 36 |
| Skewness | -0.04959792359 |
| Sum | 34118109 |
| Variance | 1723.865975 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 122 | 3355 | 0.7% |
| 105 | 3348 | 0.7% |
| 106 | 3347 | 0.7% |
| 140 | 3332 | 0.7% |
| 123 | 3328 | 0.7% |
| 134 | 3322 | 0.7% |
| 133 | 3319 | 0.7% |
| 113 | 3312 | 0.7% |
| 143 | 3305 | 0.7% |
| 94 | 3303 | 0.7% |
| Other values (135) | 422969 |
| Value | Count | Frequency (%) |
| 1 | 2922 | |
| 2 | 2896 | |
| 3 | 2899 | |
| 4 | 2889 | |
| 5 | 2810 | |
| 6 | 2823 | |
| 7 | 2769 | |
| 8 | 2785 | |
| 9 | 2854 | |
| 10 | 2859 |
| Value | Count | Frequency (%) |
| 145 | 3268 | |
| 144 | 3302 | |
| 143 | 3305 | |
| 142 | 3238 | |
| 141 | 3263 | |
| 140 | 3332 | |
| 139 | 3279 | |
| 138 | 3278 | |
| 137 | 3283 | |
| 136 | 3273 |
| Distinct | 77 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 82.10862485 |
| Minimum | 10 |
|---|---|
| Maximum | 186 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 14 |
| Q1 | 43 |
| median | 76 |
| Q3 | 110 |
| 95-th percentile | 161 |
| Maximum | 186 |
| Range | 176 |
| Interquartile range (IQR) | 67 |
Descriptive statistics
| Standard deviation | 45.97466228 |
|---|---|
| Coefficient of variation (CV) | 0.5599248844 |
| Kurtosis | -0.805091574 |
| Mean | 82.10862485 |
| Median Absolute Deviation (MAD) | 33 |
| Skewness | 0.3452015749 |
| Sum | 37461239 |
| Variance | 2113.669572 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13 | 7026 | 1.5% |
| 10 | 7006 | 1.5% |
| 52 | 6983 | 1.5% |
| 43 | 6922 | 1.5% |
| 67 | 6904 | 1.5% |
| 174 | 6883 | 1.5% |
| 51 | 6873 | 1.5% |
| 137 | 6873 | 1.5% |
| 27 | 6849 | 1.5% |
| 108 | 6838 | 1.5% |
| Other values (67) | 387083 |
| Value | Count | Frequency (%) |
| 10 | 7006 | |
| 11 | 6790 | |
| 13 | 7026 | |
| 14 | 6040 | |
| 17 | 6333 | |
| 20 | 6671 | |
| 23 | 6433 | |
| 24 | 5232 | |
| 26 | 5084 | |
| 27 | 6849 |
| Value | Count | Frequency (%) |
| 186 | 5528 | |
| 177 | 5296 | |
| 174 | 6883 | |
| 162 | 4366 | |
| 161 | 5591 | |
| 157 | 5709 | |
| 153 | 6693 | |
| 152 | 5917 | |
| 149 | 5021 | |
| 146 | 6161 |
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2024.306922 |
| Minimum | 1062 |
|---|---|
| Maximum | 2956 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 1062 |
|---|---|
| 5-th percentile | 1198 |
| Q1 | 1558 |
| median | 1993 |
| Q3 | 2539 |
| 95-th percentile | 2760 |
| Maximum | 2956 |
| Range | 1894 |
| Interquartile range (IQR) | 981 |
Descriptive statistics
| Standard deviation | 547.5381884 |
|---|---|
| Coefficient of variation (CV) | 0.2704818042 |
| Kurtosis | -1.243793678 |
| Mean | 2024.306922 |
| Median Absolute Deviation (MAD) | 499 |
| Skewness | -0.1726072093 |
| Sum | 923569790 |
| Variance | 299798.0677 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1062 | 11137 | 2.4% |
| 2707 | 11123 | 2.4% |
| 1778 | 11121 | 2.4% |
| 1109 | 11119 | 2.4% |
| 1727 | 11119 | 2.4% |
| 1993 | 11115 | 2.4% |
| 1962 | 11114 | 2.4% |
| 1754 | 11087 | 2.4% |
| 1885 | 11080 | 2.4% |
| 2581 | 11072 | 2.4% |
| Other values (41) | 345153 |
| Value | Count | Frequency (%) |
| 1062 | 11137 | |
| 1109 | 11119 | |
| 1198 | 4206 | 0.9% |
| 1207 | 10806 | |
| 1216 | 9695 | |
| 1230 | 10745 | |
| 1247 | 7184 | |
| 1248 | 9939 | |
| 1311 | 4682 | |
| 1438 | 4385 | 1.0% |
| Value | Count | Frequency (%) |
| 2956 | 3319 | 0.7% |
| 2867 | 8092 | |
| 2826 | 11056 | |
| 2760 | 10209 | |
| 2707 | 11123 | |
| 2704 | 9811 | |
| 2664 | 9853 | |
| 2640 | 10747 | |
| 2631 | 10458 | |
| 2581 | 11072 |
preco_checkout
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 1990 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 332.3371971 |
| Minimum | 45.62 |
|---|---|
| Maximum | 767.33 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 45.62 |
|---|---|
| 5-th percentile | 121.28 |
| Q1 | 228.98 |
| median | 296.82 |
| Q3 | 445.23 |
| 95-th percentile | 640.23 |
| Maximum | 767.33 |
| Range | 721.71 |
| Interquartile range (IQR) | 216.25 |
Descriptive statistics
| Standard deviation | 152.9378086 |
|---|---|
| Coefficient of variation (CV) | 0.4601886575 |
| Kurtosis | -0.2537255609 |
| Mean | 332.3371971 |
| Median Absolute Deviation (MAD) | 104.73 |
| Skewness | 0.6715232236 |
| Sum | 151625522.8 |
| Variance | 23389.97329 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 290.03 | 7340 | 1.6% |
| 291.03 | 7275 | 1.6% |
| 292.03 | 7199 | 1.6% |
| 486.03 | 6635 | 1.5% |
| 484.03 | 6631 | 1.5% |
| 485.03 | 6584 | 1.4% |
| 280.33 | 5833 | 1.3% |
| 281.33 | 5828 | 1.3% |
| 282.33 | 5729 | 1.3% |
| 447.23 | 5240 | 1.1% |
| Other values (1980) | 391946 |
| Value | Count | Frequency (%) |
| 45.62 | 1 | < 0.1% |
| 47.59 | 1 | < 0.1% |
| 53.41 | 1 | < 0.1% |
| 55.35 | 3 | |
| 56.26 | 1 | < 0.1% |
| 58.26 | 1 | < 0.1% |
| 64.02 | 3 | |
| 65.02 | 5 | |
| 65.96 | 1 | < 0.1% |
| 66.02 | 6 |
| Value | Count | Frequency (%) |
| 767.33 | 217 | |
| 766.33 | 222 | |
| 765.33 | 184 | |
| 760.54 | 2 | < 0.1% |
| 759.57 | 1 | < 0.1% |
| 759.54 | 1 | < 0.1% |
| 758.54 | 1 | < 0.1% |
| 757.63 | 2 | < 0.1% |
| 756.63 | 2 | < 0.1% |
| 755.66 | 1 | < 0.1% |
| Distinct | 1907 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 354.192825 |
| Minimum | 55.35 |
|---|---|
| Maximum | 866.27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 55.35 |
|---|---|
| 5-th percentile | 144.53 |
| Q1 | 243.5 |
| median | 310.46 |
| Q3 | 459.81 |
| 95-th percentile | 668.33 |
| Maximum | 866.27 |
| Range | 810.92 |
| Interquartile range (IQR) | 216.31 |
Descriptive statistics
| Standard deviation | 160.7554415 |
|---|---|
| Coefficient of variation (CV) | 0.4538641954 |
| Kurtosis | -0.5079199783 |
| Mean | 354.192825 |
| Median Absolute Deviation (MAD) | 111.49 |
| Skewness | 0.6370089178 |
| Sum | 161596934.5 |
| Variance | 25842.31198 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 292.03 | 9509 | 2.1% |
| 290.03 | 9381 | 2.1% |
| 291.03 | 9377 | 2.1% |
| 280.33 | 6837 | 1.5% |
| 282.33 | 6561 | 1.4% |
| 281.33 | 6476 | 1.4% |
| 445.23 | 6304 | 1.4% |
| 446.23 | 6262 | 1.4% |
| 447.23 | 6229 | 1.4% |
| 486.03 | 5607 | 1.2% |
| Other values (1897) | 383697 |
| Value | Count | Frequency (%) |
| 55.35 | 1 | |
| 64.02 | 1 | |
| 65.02 | 1 | |
| 66.02 | 1 | |
| 72.75 | 1 | |
| 73.75 | 1 | |
| 74.75 | 1 | |
| 75.66 | 1 | |
| 79.54 | 1 | |
| 81.54 | 2 |
| Value | Count | Frequency (%) |
| 866.27 | 2 | < 0.1% |
| 865.27 | 4 | < 0.1% |
| 864.27 | 1 | < 0.1% |
| 767.33 | 284 | |
| 766.33 | 282 | |
| 765.33 | 292 | |
| 760.54 | 1 | < 0.1% |
| 759.57 | 1 | < 0.1% |
| 759.54 | 1 | < 0.1% |
| 758.54 | 2 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 445.7 KiB |
| False | |
|---|---|
| True | 36784 |
| Value | Count | Frequency (%) |
| False | 419456 | |
| True | 36784 | 8.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 445.7 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 406617 | |
| True | 49623 | 10.9% |
| Distinct | 994 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.870489116 |
| Minimum | 2.564949357 |
|---|---|
| Maximum | 8.466110401 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 2.564949357 |
|---|---|
| 5-th percentile | 2.63905733 |
| Q1 | 3.988984047 |
| median | 4.912654886 |
| Q3 | 5.780743516 |
| 95-th percentile | 6.776506992 |
| Maximum | 8.466110401 |
| Range | 5.901161044 |
| Interquartile range (IQR) | 1.791759469 |
Descriptive statistics
| Standard deviation | 1.215326969 |
|---|---|
| Coefficient of variation (CV) | 0.2495287311 |
| Kurtosis | -0.6372417251 |
| Mean | 4.870489116 |
| Median Absolute Deviation (MAD) | 0.9103910097 |
| Skewness | -0.06512203977 |
| Sum | 2222111.954 |
| Variance | 1.477019641 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2.564949357 | 12397 | 2.7% |
| 2.708050201 | 12294 | 2.7% |
| 2.63905733 | 12269 | 2.7% |
| 3.33220451 | 11548 | 2.5% |
| 3.295836866 | 11462 | 2.5% |
| 3.258096538 | 11457 | 2.5% |
| 3.713572067 | 10344 | 2.3% |
| 3.688879454 | 10179 | 2.2% |
| 3.737669618 | 10083 | 2.2% |
| 3.988984047 | 8845 | 1.9% |
| Other values (984) | 345362 |
| Value | Count | Frequency (%) |
| 2.564949357 | 12397 | |
| 2.63905733 | 12269 | |
| 2.708050201 | 12294 | |
| 3.258096538 | 11457 | |
| 3.295836866 | 11462 | |
| 3.33220451 | 11548 | |
| 3.688879454 | 10179 | |
| 3.713572067 | 10344 | |
| 3.737669618 | 10083 | |
| 3.970291914 | 8715 |
| Value | Count | Frequency (%) |
| 8.466110401 | 1 | < 0.1% |
| 8.463581422 | 2 | |
| 8.460834458 | 3 | |
| 8.46062284 | 1 | < 0.1% |
| 8.457867725 | 2 | |
| 8.457655479 | 2 | |
| 8.455104999 | 3 | |
| 8.454679286 | 1 | < 0.1% |
| 8.452121195 | 1 | < 0.1% |
| 8.451907725 | 1 | < 0.1% |
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 446.3 KiB |
| Beverages | |
|---|---|
| Rice Bowl | |
| Sandwich | |
| Pizza | |
| Starters | |
| Other values (9) |
Length
| Max length | 12 |
|---|---|
| Median length | 8 |
| Mean length | 7.530481764 |
| Min length | 4 |
Characters and Unicode
| Total characters | 3435707 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Beverages |
|---|---|
| 2nd row | Beverages |
| 3rd row | Beverages |
| 4th row | Beverages |
| 5th row | Beverages |
Common Values
| Value | Count | Frequency (%) |
| Beverages | 127876 | |
| Rice Bowl | 33215 | 7.3% |
| Sandwich | 33205 | 7.3% |
| Pizza | 33138 | 7.3% |
| Starters | 29941 | 6.6% |
| Other Snacks | 29379 | 6.4% |
| Desert | 29294 | 6.4% |
| Salad | 28545 | 6.3% |
| Pasta | 27694 | 6.1% |
| Seafood | 26915 | 5.9% |
| Other values (4) | 57038 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| beverages | 127876 | |
| bowl | 33215 | 6.4% |
| rice | 33215 | 6.4% |
| sandwich | 33205 | 6.4% |
| pizza | 33138 | 6.4% |
| starters | 29941 | 5.8% |
| other | 29379 | 5.7% |
| snacks | 29379 | 5.7% |
| desert | 29294 | 5.6% |
| salad | 28545 | 5.5% |
| Other values (6) | 111647 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 561666 | |
| a | 427108 | |
| r | 280607 | 8.2% |
| s | 267933 | 7.8% |
| B | 181705 | 5.3% |
| S | 160660 | 4.7% |
| t | 159811 | 4.7% |
| i | 150973 | 4.4% |
| v | 127876 | 3.7% |
| g | 127876 | 3.7% |
| Other values (21) | 989492 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2854279 | |
| Uppercase Letter | 518834 | 15.1% |
| Space Separator | 62594 | 1.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 561666 | |
| a | 427108 | |
| r | 280607 | |
| s | 267933 | |
| t | 159811 | 5.6% |
| i | 150973 | 5.3% |
| v | 127876 | 4.5% |
| g | 127876 | 4.5% |
| o | 99720 | 3.5% |
| c | 95799 | 3.4% |
| Other values (12) | 554910 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 181705 | |
| S | 160660 | |
| P | 60832 | 11.7% |
| R | 33215 | 6.4% |
| O | 29379 | 5.7% |
| D | 29294 | 5.6% |
| E | 13562 | 2.6% |
| F | 10187 | 2.0% |
Space Separator
| Value | Count | Frequency (%) |
| 62594 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3373113 | |
| Common | 62594 | 1.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 561666 | |
| a | 427108 | |
| r | 280607 | 8.3% |
| s | 267933 | 7.9% |
| B | 181705 | 5.4% |
| S | 160660 | 4.8% |
| t | 159811 | 4.7% |
| i | 150973 | 4.5% |
| v | 127876 | 3.8% |
| g | 127876 | 3.8% |
| Other values (20) | 926898 |
Common
| Value | Count | Frequency (%) |
| 62594 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3435707 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 561666 | |
| a | 427108 | |
| r | 280607 | 8.2% |
| s | 267933 | 7.8% |
| B | 181705 | 5.3% |
| S | 160660 | 4.7% |
| t | 159811 | 4.7% |
| i | 150973 | 4.4% |
| v | 127876 | 3.7% |
| g | 127876 | 3.7% |
| Other values (21) | 989492 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 445.9 KiB |
| Italian | |
|---|---|
| Thai | |
| Indian | |
| Continental |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 6.877573207 |
| Min length | 4 |
Characters and Unicode
| Total characters | 3137824 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Thai |
|---|---|
| 2nd row | Thai |
| 3rd row | Thai |
| 4th row | Thai |
| 5th row | Thai |
Common Values
| Value | Count | Frequency (%) |
| Italian | 122825 | |
| Thai | 118203 | |
| Indian | 112419 | |
| Continental | 102793 |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| italian | 122825 | |
| thai | 118203 | |
| indian | 112419 | |
| continental | 102793 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 656042 | |
| a | 579065 | |
| i | 456240 | |
| t | 328411 | |
| I | 235244 | 7.5% |
| l | 225618 | 7.2% |
| T | 118203 | 3.8% |
| h | 118203 | 3.8% |
| d | 112419 | 3.6% |
| C | 102793 | 3.3% |
| Other values (2) | 205586 | 6.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2681584 | |
| Uppercase Letter | 456240 | 14.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 656042 | |
| a | 579065 | |
| i | 456240 | |
| t | 328411 | |
| l | 225618 | 8.4% |
| h | 118203 | 4.4% |
| d | 112419 | 4.2% |
| o | 102793 | 3.8% |
| e | 102793 | 3.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 235244 | |
| T | 118203 | |
| C | 102793 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3137824 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 656042 | |
| a | 579065 | |
| i | 456240 | |
| t | 328411 | |
| I | 235244 | 7.5% |
| l | 225618 | 7.2% |
| T | 118203 | 3.8% |
| h | 118203 | 3.8% |
| d | 112419 | 3.6% |
| C | 102793 | 3.3% |
| Other values (2) | 205586 | 6.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3137824 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 656042 | |
| a | 579065 | |
| i | 456240 | |
| t | 328411 | |
| I | 235244 | 7.5% |
| l | 225618 | 7.2% |
| T | 118203 | 3.8% |
| h | 118203 | 3.8% |
| d | 112419 | 3.6% |
| C | 102793 | 3.3% |
| Other values (2) | 205586 | 6.6% |
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 601.5494455 |
| Minimum | 456 |
|---|---|
| Maximum | 713 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 456 |
|---|---|
| 5-th percentile | 478 |
| Q1 | 553 |
| median | 596 |
| Q3 | 651 |
| 95-th percentile | 700 |
| Maximum | 713 |
| Range | 257 |
| Interquartile range (IQR) | 98 |
Descriptive statistics
| Standard deviation | 66.20361943 |
|---|---|
| Coefficient of variation (CV) | 0.1100551583 |
| Kurtosis | -0.7912046047 |
| Mean | 601.5494455 |
| Median Absolute Deviation (MAD) | 53 |
| Skewness | -0.2090812318 |
| Sum | 274450919 |
| Variance | 4382.919226 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 590 | 54635 | 12.0% |
| 526 | 43508 | 9.5% |
| 638 | 20028 | 4.4% |
| 522 | 13456 | 2.9% |
| 517 | 13105 | 2.9% |
| 604 | 13052 | 2.9% |
| 699 | 12089 | 2.6% |
| 647 | 11818 | 2.6% |
| 576 | 11451 | 2.5% |
| 614 | 11330 | 2.5% |
| Other values (41) | 251768 |
| Value | Count | Frequency (%) |
| 456 | 6713 | 1.5% |
| 461 | 5762 | 1.3% |
| 473 | 5853 | 1.3% |
| 478 | 5021 | 1.1% |
| 485 | 5707 | 1.3% |
| 515 | 5084 | 1.1% |
| 517 | 13105 | 2.9% |
| 522 | 13456 | 2.9% |
| 526 | 43508 | |
| 541 | 4501 | 1.0% |
| Value | Count | Frequency (%) |
| 713 | 6849 | |
| 703 | 6703 | |
| 702 | 5264 | |
| 700 | 6883 | |
| 699 | 12089 | |
| 698 | 6433 | |
| 695 | 5294 | |
| 693 | 4627 | 1.0% |
| 685 | 6983 | |
| 683 | 5296 |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.61246274 |
| Minimum | 23 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 23 |
|---|---|
| 5-th percentile | 34 |
| Q1 | 34 |
| median | 56 |
| Q3 | 77 |
| 95-th percentile | 85 |
| Maximum | 93 |
| Range | 70 |
| Interquartile range (IQR) | 43 |
Descriptive statistics
| Standard deviation | 17.64357046 |
|---|---|
| Coefficient of variation (CV) | 0.3116552365 |
| Kurtosis | -1.05161428 |
| Mean | 56.61246274 |
| Median Absolute Deviation (MAD) | 21 |
| Skewness | 0.05627398237 |
| Sum | 25828870 |
| Variance | 311.2955787 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 56 | 191022 | |
| 34 | 116686 | |
| 77 | 94580 | |
| 85 | 30268 | 6.6% |
| 23 | 6433 | 1.4% |
| 71 | 6278 | 1.4% |
| 93 | 5709 | 1.3% |
| 35 | 5264 | 1.2% |
| Value | Count | Frequency (%) |
| 23 | 6433 | 1.4% |
| 34 | 116686 | |
| 35 | 5264 | 1.2% |
| 56 | 191022 | |
| 71 | 6278 | 1.4% |
| 77 | 94580 | |
| 85 | 30268 | 6.6% |
| 93 | 5709 | 1.3% |
| Value | Count | Frequency (%) |
| 93 | 5709 | 1.3% |
| 85 | 30268 | 6.6% |
| 77 | 94580 | |
| 71 | 6278 | 1.4% |
| 56 | 191022 | |
| 35 | 5264 | 1.2% |
| 34 | 116686 | |
| 23 | 6433 | 1.4% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 445.8 KiB |
| TYPE_A | |
|---|---|
| TYPE_C | |
| TYPE_B |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 2737440 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TYPE_C |
|---|---|
| 2nd row | TYPE_C |
| 3rd row | TYPE_C |
| 4th row | TYPE_C |
| 5th row | TYPE_C |
Common Values
| Value | Count | Frequency (%) |
| TYPE_A | 262689 | |
| TYPE_C | 99544 | 21.8% |
| TYPE_B | 94007 | 20.6% |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| type_a | 262689 | |
| type_c | 99544 | 21.8% |
| type_b | 94007 | 20.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 456240 | |
| Y | 456240 | |
| P | 456240 | |
| E | 456240 | |
| _ | 456240 | |
| A | 262689 | |
| C | 99544 | 3.6% |
| B | 94007 | 3.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2281200 | |
| Connector Punctuation | 456240 | 16.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 456240 | |
| Y | 456240 | |
| P | 456240 | |
| E | 456240 | |
| A | 262689 | |
| C | 99544 | 4.4% |
| B | 94007 | 4.1% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 456240 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2281200 | |
| Common | 456240 | 16.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 456240 | |
| Y | 456240 | |
| P | 456240 | |
| E | 456240 | |
| A | 262689 | |
| C | 99544 | 4.4% |
| B | 94007 | 4.1% |
Common
| Value | Count | Frequency (%) |
| _ | 456240 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2737440 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 456240 | |
| Y | 456240 | |
| P | 456240 | |
| E | 456240 | |
| _ | 456240 | |
| A | 262689 | |
| C | 99544 | 3.6% |
| B | 94007 | 3.4% |
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.083081711 |
| Minimum | 0.9 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.5 MiB |
Quantile statistics
| Minimum | 0.9 |
|---|---|
| 5-th percentile | 2.7 |
| Q1 | 3.6 |
| median | 4 |
| Q3 | 4.5 |
| 95-th percentile | 6.7 |
| Maximum | 7 |
| Range | 6.1 |
| Interquartile range (IQR) | 0.9 |
Descriptive statistics
| Standard deviation | 1.091530289 |
|---|---|
| Coefficient of variation (CV) | 0.2673300134 |
| Kurtosis | 1.452919071 |
| Mean | 4.083081711 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.6645434202 |
| Sum | 1862865.2 |
| Variance | 1.191438371 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=30)
| Value | Count | Frequency (%) |
| 4 | 52514 | 11.5% |
| 3.9 | 48523 | 10.6% |
| 3.8 | 40066 | 8.8% |
| 4.4 | 26030 | 5.7% |
| 4.5 | 25652 | 5.6% |
| 2.8 | 25500 | 5.6% |
| 4.1 | 23330 | 5.1% |
| 7 | 20660 | 4.5% |
| 4.8 | 18642 | 4.1% |
| 3.4 | 17257 | 3.8% |
| Other values (20) | 158066 |
| Value | Count | Frequency (%) |
| 0.9 | 3432 | 0.8% |
| 1.9 | 4083 | 0.9% |
| 2 | 9512 | 2.1% |
| 2.4 | 5021 | 1.1% |
| 2.7 | 12427 | |
| 2.8 | 25500 | |
| 2.9 | 4711 | 1.0% |
| 3 | 11182 | |
| 3.2 | 6333 | 1.4% |
| 3.4 | 17257 |
| Value | Count | Frequency (%) |
| 7 | 20660 | |
| 6.7 | 7026 | 1.5% |
| 6.3 | 7006 | 1.5% |
| 5.6 | 6983 | 1.5% |
| 5.3 | 6051 | 1.3% |
| 5.1 | 13310 | |
| 5 | 6161 | 1.4% |
| 4.8 | 18642 | |
| 4.7 | 5975 | 1.3% |
| 4.6 | 5975 | 1.3% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| df_index | semana | loja_id | refeicao_id | preco_checkout | preco_base | email_para_promocao | pagina_destaque | qtd_pedido | categoria | cozinha | cidade_codigo | regiao_codigo | loja_tipo | op_area | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 1 | 55 | 1885 | 136.83 | 152.29 | False | False | 5.176150 | Beverages | Thai | 647 | 56 | TYPE_C | 2.0 |
| 1 | 1 | 2 | 55 | 1885 | 135.83 | 152.29 | False | False | 5.777652 | Beverages | Thai | 647 | 56 | TYPE_C | 2.0 |
| 2 | 2 | 3 | 55 | 1885 | 132.92 | 133.92 | False | False | 4.564348 | Beverages | Thai | 647 | 56 | TYPE_C | 2.0 |
| 3 | 3 | 4 | 55 | 1885 | 135.86 | 134.86 | False | False | 5.093750 | Beverages | Thai | 647 | 56 | TYPE_C | 2.0 |
| 4 | 4 | 5 | 55 | 1885 | 146.50 | 147.50 | False | False | 5.370638 | Beverages | Thai | 647 | 56 | TYPE_C | 2.0 |
| 5 | 5 | 6 | 55 | 1885 | 146.53 | 146.53 | False | False | 5.652489 | Beverages | Thai | 647 | 56 | TYPE_C | 2.0 |
| 6 | 6 | 7 | 55 | 1885 | 145.53 | 146.53 | False | False | 4.997212 | Beverages | Thai | 647 | 56 | TYPE_C | 2.0 |
| 7 | 7 | 8 | 55 | 1885 | 146.53 | 145.53 | False | False | 4.905275 | Beverages | Thai | 647 | 56 | TYPE_C | 2.0 |
| 8 | 8 | 9 | 55 | 1885 | 134.83 | 134.83 | False | False | 5.164786 | Beverages | Thai | 647 | 56 | TYPE_C | 2.0 |
| 9 | 9 | 10 | 55 | 1885 | 144.56 | 143.56 | False | False | 5.164786 | Beverages | Thai | 647 | 56 | TYPE_C | 2.0 |
Last rows
| df_index | semana | loja_id | refeicao_id | preco_checkout | preco_base | email_para_promocao | pagina_destaque | qtd_pedido | categoria | cozinha | cidade_codigo | regiao_codigo | loja_tipo | op_area | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 456230 | 456538 | 136 | 61 | 2104 | 571.33 | 573.33 | False | False | 2.708050 | Fish | Continental | 473 | 77 | TYPE_A | 4.5 |
| 456231 | 456539 | 137 | 61 | 2104 | 631.53 | 631.53 | False | False | 3.713572 | Fish | Continental | 473 | 77 | TYPE_A | 4.5 |
| 456232 | 456540 | 138 | 61 | 2104 | 631.53 | 630.53 | False | True | 5.010635 | Fish | Continental | 473 | 77 | TYPE_A | 4.5 |
| 456233 | 456541 | 139 | 61 | 2104 | 490.82 | 629.53 | False | True | 5.743003 | Fish | Continental | 473 | 77 | TYPE_A | 4.5 |
| 456234 | 456542 | 140 | 61 | 2104 | 485.03 | 629.53 | False | True | 5.003946 | Fish | Continental | 473 | 77 | TYPE_A | 4.5 |
| 456235 | 456543 | 141 | 61 | 2104 | 583.03 | 630.53 | False | True | 2.564949 | Fish | Continental | 473 | 77 | TYPE_A | 4.5 |
| 456236 | 456544 | 142 | 61 | 2104 | 581.03 | 582.03 | False | False | 3.737670 | Fish | Continental | 473 | 77 | TYPE_A | 4.5 |
| 456237 | 456545 | 143 | 61 | 2104 | 583.03 | 581.03 | False | False | 3.688879 | Fish | Continental | 473 | 77 | TYPE_A | 4.5 |
| 456238 | 456546 | 144 | 61 | 2104 | 582.03 | 581.03 | False | False | 3.970292 | Fish | Continental | 473 | 77 | TYPE_A | 4.5 |
| 456239 | 456547 | 145 | 61 | 2104 | 581.03 | 582.03 | False | False | 3.295837 | Fish | Continental | 473 | 77 | TYPE_A | 4.5 |